# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月22日
"""
import openpyxl
from PIL import Image

myBook=openpyxl.load_workbook('新书订购表.xlsx')
mySheet=myBook.active
myImage1=openpyxl.drawing.image.Image('images/myImage1.jpg')
mySheet.add_image(myImage1,'A5')
myImage2=Image.open('images/myImage2.jpg')
myImage2.rotate(90).save('temp_myImage2.jpg')
myImage2_rotate=openpyxl.drawing.image.Image('temp_myImage2.jpg')
mySheet.add_image(myImage2_rotate,'B5')

myBook.save('结果表-新书订购表.xlsx')


